package com.ktjy.ktmall.mapper.vo;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ktjy.ktmall.domain.dto.AttrWithValues;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface AttrWithMapper extends BaseMapper<AttrWithValues> {
    //2.查询商品未关联的属性
    List<AttrWithValues> selectUnassociatedAttrsAndValues(@Param("goodsId") Long goodsId);

    //3.查询商品属性关联的属性值
    List<AttrWithValues> selectAttrValuesList(@Param("attrId") Long attrId,@Param("goodsId") Long goodsId);

    //4.查询sku编码不存在对应的属性
    List<AttrWithValues> selectSkuValueVoListBySkuList(@Param("stockSku") String stockSku);

    //5.查询sku编码不存在对应属性的属性值
    List<AttrWithValues> selectSkuValueVoListBySkuIdAndAttrId(@Param("attrId") Long attrId,@Param("stockSku") String stockSku);
}
